OpenEdge Data Management:<br />Database Administration Processes/Clients

Displays status information about OpenEdge processes. The menu options allow you to choose all processes or a subset. Depending on your selection, the status display will contain a set of the columns described in Table 19–11.

Table 19–11: PROMON Processes/Clients Status display columns
Column name	Description
Usr	The user number of the process.
Name	The user name of the process.
Type	The process type. Table 19–1 lists the possible types.
Wait	The wait type. Table 19–2 describes the possible types. If no value is displayed, the process is not waiting on any database-related events.
Login Time Start Time	The time when the process logged into the database.
Trans id	The user’s transaction ID.
Tx Start Time	The time the transaction started.
Trans State	The state of the transaction. Table 19–4 lists the possible states.
Pid	The process ID number.
Serv	The server number serving the remote client.

All Processes — Displays status information about OpenEdge processes. Figure 19–13 shows a sample Processes/Clients Status display.

09/25/03 All Processes Status 16:09 Usr Name Type Wait Trans id Login time 0 SYSTEM BROK -- 0 0 09/25/03 08:31 5 BIW -- 0 0 09/25/03 08:33 6 WDOG -- 0 0 09/25/03 08:33 7 APW -- 0 0 09/25/03 08:34 8 rgw MON -- 0 0 09/25/03 08:57

09/25/03         All Processes Status 
16:09 
Usr    Name    Type  Wait             Trans id   Login time 
0      SYSTEM  BROK   --        0            0   09/25/03 08:31 
5              BIW    --        0            0   09/25/03 08:33 
6              WDOG   --        0            0   09/25/03 08:33 
7              APW    --        0            0   09/25/03 08:34 
8      rgw     MON    --        0            0   09/25/03 08:57

Figure 19–13: PROMON Processes/Clients Status display

Blocked Clients — The clients listed are waiting for a database-related resource. Figure 19–14 shows a sample Blocked Clients Status display. The clients listed are waiting for a database-related resource.


09/25/03 Status Blocked Clients 16:10 Usr Name Type Wait Trans id Login time 2 eadams SELF REC 3937 0 09/25/03 14:51

Figure 19–14: PROMON Blocked Clients Status display

Active Transactions — Displays status information about active transactions. Figure 19–15 shows a sample Active Transactions Status display.


09/25/03 Active Transactions Status 16:10 Usr Name Type Login time Tx Start Time Trans id Trans State 0 rgw SELF 09/25/03 08:31 2601 Begin

Figure 19–15: PROMON Active Transactions Status display

Local Interactive Clients — Displays status information about local interactive client processes. Figure 19–16 shows a sample Local Interactive Clients status display.


09/25/03 Local Interactive Clients Status 16:10 Usr Name Type Wait Trans id Login time Pid 0 rgw BROK MTX 0 0 09/25/03 10:31 16147

Figure 19–16: PROMON Local Interactive Clients Status display

Local Batch Clients — Displays status information about local batch client processes. Figure 19–17 shows a sample Local Batch Clients Status display.


09/25/03 Local Batch Clients Status 16:10 Usr Name Type Wait Trans id Login time Pid 0 guy SELF MTX 0 402 09/25/03 10:31 678 0 rgw SELF REC 3937 0 09/25/03 10:36 687

Figure 19–17: PROMON Local Batch Clients Status display

Remote Clients — Displays status information about remote client processes. Figure 19–18 shows a sample Remote Clients Status display.


09/25/03 Remote Clients Status 16:18 Usr Name Type Wait Trans id Login time Serv 0 rgw BROK MTX 0 0 09/25/03 10:36 0

Figure 19–18: PROMON Remote Clients Status display

Background Processes — Displays status information about background database processes. Figure 19–19 shows a sample Background Processes Status display.


09/25/03 Background Processes Status 16:10 Usr Name Type Start time Pid 0 SYSTEM BROK 09/25/03 10:31 16140 5 rgw MON 09/25/03 11:12 16145 6 BIW 09/25/03 10:33 16146

Figure 19–19: PROMON Background Processes Status display